/** 
 * @Title: PinfoUtil.java 
 * @Package com.zizo.autohome.sta.pinfo.dao 
 * @Description: TODO
 * @author HeYan
 * @date 2016年10月26日 下午4:22:37 
 */
package com.zizo.autohome.sta.pinfo.dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.zizo.util.ConnectionPool;

/**
 * @ClassName: PinfoUtil
 * @Description: TODO
 * @author HeYan
 * @date 2016年10月26日 下午4:22:37
 * 
 */
public class PinfoUtil {
	private static final Connection conn = ConnectionPool.getConnection("autohome_other", "localhost");

	public static final List<Integer> getIDs() {
		Statement st = null;
		ResultSet rs = null;
		List<Integer> list = new ArrayList<>();
		String sql = "SELECT t1.brand_autohome FROM carvoice_biz.biz_brand AS t1 WHERE t1.brand_autohome NOT IN (2041,3033,3084,3805)";
		try {
			st = conn.createStatement();
			rs = st.executeQuery(sql);
			while (rs.next()) {
				list.add(rs.getInt(1));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}

}
